﻿<?php
require_once './PHPExcel.php';
require_once './PHPExcel/IOFactory.php';
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
							 ->setLastModifiedBy("Maarten Balliauw")
							 ->setTitle("Office 2007 XLSX Test Document")
							 ->setSubject("Office 2007 XLSX Test Document")
							 ->setDescription("Document for Office 2007 XLSX, generated using PHP classes.")
							 ->setKeywords("office 2007 openxml php")
							 ->setCategory("Test result file");							 
$objPHPExcel->setActiveSheetIndex(0);

$objRichText = new PHPExcel_RichText();
$objRichText->createText('');
$objPayable = $objRichText->createTextRun('PHP导出的Excel');
$objPayable->getFont()->setColor( new PHPExcel_Style_Color( PHPExcel_Style_Color::COLOR_RED ));
$objPayable->getFont()->setBold(true);
$objPayable->getFont()->setSize(24);
$objPHPExcel->getActiveSheet()->getCell('A1')->setValue($objRichText);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);//加粗
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(14);//字体大小
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_RED);// 文本颜色
$objPHPExcel->getActiveSheet()->getStyle('A1:K1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('A1:K1')->getFill()->getStartColor()->setARGB('00FFFFE3');	// 底纹


// 列宽
//$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(18);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(18);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(18);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(20);

// 行高
for($i = 1; $i <= 17; $i++)
{
	$objPHPExcel->getActiveSheet()->getRowDimension($i)->setRowHeight(22);
}

for ($i = 0; $i <=8; $i++)
{
	$objPHPExcel->getActiveSheet()->getStyleByColumnAndRow($i, 2)->getFont()->setBold(true);//设置第二行加粗
}
$objPHPExcel->getActiveSheet()->setCellValue('A2', '姓名');
$objPHPExcel->getActiveSheet()->setCellValue('B2', '测试B2');
$objPHPExcel->getActiveSheet()->setCellValue('C2', '测试C2');
$objPHPExcel->getActiveSheet()->setCellValue('D2', '测试D2');
$objPHPExcel->getActiveSheet()->setCellValue('E2', '测试D2');
$objPHPExcel->getActiveSheet()->setCellValue('F2', '测试D2');
$objPHPExcel->getActiveSheet()->setCellValue('G2', '测试D2');
$objPHPExcel->getActiveSheet()->setCellValue('H2', '测试D2');
$objPHPExcel->getActiveSheet()->setCellValue('I2', '测试D2');
$objPHPExcel->getActiveSheet()->setCellValue('J2', '测试D2');
$objPHPExcel->getActiveSheet()->setCellValue('k2', '测试D2');

$objPHPExcel->getActiveSheet()->setCellValue('A3', 'PHP');
$objPHPExcel->getActiveSheet()->setCellValue('A4', 'EXCEL');
$objPHPExcel->getActiveSheet()->setCellValue('A5', '');
$objPHPExcel->getActiveSheet()->setCellValue('A6', 'XXX');
$objPHPExcel->getActiveSheet()->setCellValue('A7', 'V');
$objPHPExcel->getActiveSheet()->setCellValue('A8', 'd');
$objPHPExcel->getActiveSheet()->setCellValue('A9', 'name');
$objPHPExcel->getActiveSheet()->setCellValue('A10', '描述');
for($i = 2; $i <= 16; $i++)
{
	$objPHPExcel->getActiveSheet()->getStyle('A' . $i)->getFont()->setBold(true);		// 加粗
}

$objPHPExcel->getActiveSheet()->setCellValue('B2', '[姓名]');
$objPHPExcel->getActiveSheet()->setCellValue('B3', '导出带图片的EXCEL');
$objPHPExcel->getActiveSheet()->setCellValue('B4', 'XXXXX');

// 为excel加图片
$objDrawing = new PHPExcel_Worksheet_Drawing();
$objDrawing->setName('Photo');
$objDrawing->setDescription('Photo');
$objDrawing->setPath('./images/PIC.jpg');
$objDrawing->setHeight(170);
$objDrawing->setWidth(120);
$objDrawing->setCoordinates('G2');
$objDrawing->setWorksheet($objPHPExcel->getActiveSheet());

$objPHPExcel->getActiveSheet()->setCellValue('A17', '其它要求');
$objPHPExcel->getActiveSheet()->setCellValue('B17', '[其它要求]');

$objPHPExcel->getActiveSheet()->getStyle('A17')->getFont()->setBold(true);		// 加粗

$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->setTitle('Excel表');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');

//$objWriter->save('php://output');
$objWriter->save('PHP导出Excel.xls');
?>